package com.hongdee.crm.task.mapper;

import org.apache.ibatis.jdbc.SQL;

import java.util.Map;

/**
 * Created by Liu XiaoLong
 * Date: 2017/12/21.
 * Remark:
 */
public class ITCrmTaskRealQuery {
    private String tableName = "t_crm_task_real";

    public String getPlateNumForInsuranceTaskToday(Map map) {
        String date = (String) map.get("date");
        SQL sql = new SQL(){
            {
                SELECT("plateNum");
                FROM(tableName);
                WHERE("expect_date = #{date} AND type_pcode = 'bx' AND `status` = '0' AND company_id = #{companyId} ");//AND type_pcode = 'bx' AND `status` = '0'
            }
        };
        return sql.toString();
    }
}
